{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INPUT HOURS & CALC FRINGES","TRADES_RATES","TOTALS and CERTIFY"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INPUT HOURS & CALC FRINGES","index":0,"n_rows":49,"n_cols":29,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,11],[45,12,46,12],[46,6,46,10],[47,6,47,10],[1,0,1,4],[3,1,3,3],[4,1,4,3],[45,0,45,4],[9,8,9,11],[48,6,48,10],[45,6,45,10],[2,7,2,11],[3,7,3,11],[4,7,4,11],[2,5,2,6],[3,5,3,6],[4,5,4,6],[45,20,45,27],[5,1,5,3],[9,0,9,5],[9,6,9,7],[5,5,5,6],[6,5,6,6],[7,5,7,6],[5,7,5,11],[6,7,6,11],[7,7,7,11],[9,15,9,27],[45,14,46,14]]}
["Fringe Benefit Remittance Form to PIPE TRADES SERVICES MN"]
["On Behalf of EMPLOYEES WORKING UNDER JURISDICTION OF Sprinklersfitters Local 417"]
["For Payroll Periods: June 1, 2018 - May 31, 2019",null,null,null,null,"Employer Tax ID:"]
["Last Payroll Date Paid:",null,null,null,null,"Employer Name:"]
["Report for the Month of:",null,null,null,null,"Office Address:"]
[null,null,null,null,null,"City, State  Zip: "]
["Check here if there will be no hours to report next month",null,null,null,null,"Phone #"]
[null,null,null,null,null,"Fax #"]
[]
["Enter Monthly Reporting",null,null,null,null,null,"Total Hours",null,"PYRAMID FRINGES",null,null,null,null,null,null,"NON PYRAMID FRINGES"]
["NAME OF EMPLOYEE                 (in alphabetical order by lastname, firstname)","SOC. SEC. #    (123-45-6789)","TRADE CODE","REGULAR     TIME","TIME            & 1/2","DOUBLE     TIME","TOTAL HOURS WORKED","TOTAL HOURS that PYRAMID","Dues Rate","Total Dues","H&W Rate","Total H&W","Total Pyramid Fringes","Total Non Pyramid Fringes","Total Fringe to PTSMN","Supplement Pension Rate","Total Supplement Pension","Apprenticeship Rate","Total Apprenticeship","Industry Promotion Rate","Total Industry Promotion","Building Fund Rate","Total Building Fund","UA Training Rate","Total UA Training","Vacation Rate","Total for Vacation","Total Non Pyramid Fringes","Total Fringe to PTSMN"]
[null,null,null,null,null,null,{"$f":"SUM(D12:F12)","v":0},{"$f":"D12+(E12*1.5)+(F12*2)","v":0},{"$f":"IF($H12 <> 0, (VLOOKUP($C12,TRADE_RATES,11,FALSE)),0)","v":0},{"$f":"ROUND($H12*$I12,2)","v":0},{"$f":"IF($H12 <> 0, (VLOOKUP($C12,TRADE_RATES,3,FALSE)),0)","v":0},{"$f":"ROUND($H12*$K12,2)","v":0},{"$f":"SUM(J12,L12)","v":0},{"$f":"Q12+S12+U12+W12+Y12+AA12","v":0},{"$f":"SUM(J12,L12,Q12,S12,U12,W12,Y12,AA12)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,5,FALSE)),0)","v":0},{"$f":"ROUND($G12*$P12,2)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,6,FALSE)),0)","v":0},{"$f":"ROUND($G12*$R12,2)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,7,FALSE)),0)","v":0},{"$f":"ROUND($G12*$T12,2)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,8,FALSE)),0)","v":0},{"$f":"ROUND($G12*$V12,2)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,9,FALSE)),0)","v":0},{"$f":"ROUND($G12*$X12,2)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,10,FALSE)),0)","v":0},{"$f":"ROUND($G12*$Z12,2)","v":0},{"$f":"Q12+S12+U12+W12+Y12+AA12","v":0},{"$f":"SUM(J12,L12,Q12,S12,U12,W12,Y12,AA12)","v":0}]
[null,null,null,null,null,null,0,0,0,{"$f":"ROUND($H13*$I13,2)","v":0},{"$f":"IF($H13 <> 0, (VLOOKUP($C13,TRADE_RATES,3,FALSE)),0)","v":0},{"$f":"ROUND($H13*$K13,2)","v":0},0,0,0,{"$f":"IF($G13 <> 0, (VLOOKUP($C13,TRADE_RATES,5,FALSE)),0)","v":0},{"$f":"ROUND($G13*$P13,2)","v":0},{"$f":"IF($G13 <> 0, (VLOOKUP($C13,TRADE_RATES,6,FALSE)),0)","v":0},{"$f":"ROUND($G13*$R13,2)","v":0},{"$f":"IF($G13 <> 0, (VLOOKUP($C13,TRADE_RATES,7,FALSE)),0)","v":0},{"$f":"ROUND($G13*$T13,2)","v":0},0,0,0,0,0,0,{"$f":"Q13+S13+U13+W13+Y13+AA13","v":0},0]
[null,null,null,null,null,null,{"$f":"SUM(D14:F14)","v":0},{"$f":"D14+(E14*1.5)+(F14*2)","v":0},0,{"$f":"ROUND($H14*$I14,2)","v":0},{"$f":"IF($H14 <> 0, (VLOOKUP($C14,TRADE_RATES,3,FALSE)),0)","v":0},{"$f":"ROUND($H14*$K14,2)","v":0},0,0,0,{"$f":"IF($G14 <> 0, (VLOOKUP($C14,TRADE_RATES,5,FALSE)),0)","v":0},{"$f":"ROUND($G14*$P14,2)","v":0},{"$f":"IF($G14 <> 0, (VLOOKUP($C14,TRADE_RATES,6,FALSE)),0)","v":0},{"$f":"ROUND($G14*$R14,2)","v":0},{"$f":"IF($G14 <> 0, (VLOOKUP($C14,TRADE_RATES,7,FALSE)),0)","v":0},{"$f":"ROUND($G14*$T14,2)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(J14,L14,Q14,S14,U14,W14,Y14,AA14)","v":0}]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(D27:F27)","v":0},{"$f":"D27+(E27*1.5)+(F27*2)","v":0},0,0,0,0,0,0,{"$f":"SUM(J27,L27,Q27,S27,U27,W27,Y27,AA27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q27+S27+U27+W27+Y27+AA27","v":0},{"$f":"SUM(J27,L27,Q27,S27,U27,W27,Y27,AA27)","v":0}]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(D42:F42)","v":0},{"$f":"D42+(E42*1.5)+(F42*2)","v":0},{"$f":"IF($H42 <> 0, (VLOOKUP($C42,TRADE_RATES,11,FALSE)),0)","v":0},{"$f":"ROUND($H42*$I42,2)","v":0},{"$f":"IF($H42 <> 0, (VLOOKUP($C42,TRADE_RATES,3,FALSE)),0)","v":0},{"$f":"ROUND($H42*$K42,2)","v":0},{"$f":"SUM(J42,L42)","v":0},{"$f":"Q42+S42+U42+W42+Y42+AA42","v":0},{"$f":"SUM(J42,L42,Q42,S42,U42,W42,Y42,AA42)","v":0},{"$f":"IF($G42 <> 0, (VLOOKUP($C42,TRADE_RATES,5,FALSE)),0)","v":0},{"$f":"ROUND($G42*$P42,2)","v":0},{"$f":"IF($G42 <> 0, (VLOOKUP($C42,TRADE_RATES,6,FALSE)),0)","v":0},{"$f":"ROUND($G42*$R42,2)","v":0},{"$f":"IF($G42 <> 0, (VLOOKUP($C42,TRADE_RATES,7,FALSE)),0)","v":0},{"$f":"ROUND($G42*$T42,2)","v":0},{"$f":"IF($G42 <> 0, (VLOOKUP($C42,TRADE_RATES,8,FALSE)),0)","v":0},{"$f":"ROUND($G42*$V42,2)","v":0},{"$f":"IF($G42 <> 0, (VLOOKUP($C42,TRADE_RATES,9,FALSE)),0)","v":0},{"$f":"ROUND($G42*$X42,2)","v":0},{"$f":"IF($G42 <> 0, (VLOOKUP($C42,TRADE_RATES,10,FALSE)),0)","v":0},{"$f":"ROUND($G42*$Z42,2)","v":0},{"$f":"Q42+S42+U42+W42+Y42+AA42","v":0},{"$f":"SUM(J42,L42,Q42,S42,U42,W42,Y42,AA42)","v":0}]
[" "]
[null,"Total Hours:",null,{"$f":"SUM(D12:D42)","v":0},{"$f":"SUM(E12:E42)","v":0},{"$f":"SUM(F12:F42)","v":0},{"$f":"SUM(G12:G42)","v":0},{"$f":"SUM(H12:H42)","v":0},null,{"$f":"SUM(J12:J42)","v":0},null,{"$f":"SUM(L12:L42)","v":0},{"$f":"SUM(M12:M42)","v":0},{"$f":"SUM(N12:N42)","v":0},{"$f":"SUM(AC12:AC42)","v":0},null,{"$f":"SUM(Q12:Q42)","v":0},null,{"$f":"SUM(S12:S42)","v":0},null,{"$f":"SUM(U12:U42)","v":0},null,{"$f":"SUM(W12:W42)","v":0},null,{"$f":"SUM(Y12:Y42)","v":0},null,{"$f":"SUM(AA12:AA42)","v":0},{"$f":"SUM(AB12:AB42)","v":0},{"$f":"SUM(AC12:AC42)","v":0}]
[]
["Mail 1 copy (use \"Print for PTSMN\" button above) with a check before the 15th of the month to:",null,null,null,null,null,null,null,null,null,null,null,"GRAND TOTAL TO PTSMN:",null,{"$f":"AC44","v":0},null,null,null,null,null,"GRAND TOTAL FRINGES TO REMIT TO PTSMN with copy of this sheet: ",null,null,null,null,null,null,null,{"$f":"AC44","v":0}]
["PIPE TRADES SERVICES MN"]
["4461 White Bear Pkwy, Suite1"]
["White Bear Lake, MN 55110"]

{"sheet":"TRADES_RATES","index":1,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,8],[0,0,0,13]]}
["TRADE RATES GRID"]
["NON TAXABLE FRINGE",null,null,null,null,null,null,null,null,"TAXABLE","TAXABLE"]
["Trade Code","Trade Description","Health & Welfare",null,"Supplement Pension","Apprenticeship","Industry Promotion","Building Fund","UA Training Fund","Credit Union (Vacation Fund)","Dues","TOTAL PD FRINGE","TOTAL WORKED FRINGE","Total Fringe to PTSMN"]
[null,null,"PD",null,"WRK","WRK","WRK","WRK","WRK","WRK","PD"]
["SP","Apprentice Probationary",9.36,null,null,0.59,0.56999999999999995,0.1,0.1,1,0.85,{"$f":"SUM(C5,K5)","v":10.209999999999999},{"$f":"SUM(E5:J5)","v":2.3600000000000003},{"$f":"L5+M5","v":12.57}]
["S1","Apprentice 1",9.36,null,null,0.59,0.56999999999999995,0.1,0.1,1,0.85,{"$f":"SUM(C6,K6)","v":10.209999999999999},{"$f":"SUM(E6:J6)","v":2.3600000000000003},{"$f":"L6+M6","v":12.57}]
["S2","Apprentice 2",9.36,null,null,0.59,0.56999999999999995,0.1,0.1,1,0.85,10.209999999999999,2.3600000000000003,12.57]
["S3","Apprentice 3",9.36,null,null,0.59,0.56999999999999995,0.1,0.1,1,0.94,10.299999999999999,2.3600000000000003,12.66]
["S4","Apprentice 4",9.36,null,null,0.59,0.56999999999999995,0.1,0.1,1,1.03,10.389999999999999,2.3600000000000003,12.75]
["S5","Apprentice 5",9.36,null,10,0.59,0.56999999999999995,0.1,0.1,1,1.1200000000000001,10.48,12.36,22.84]
["S6","Apprentice 6",9.36,null,10,0.59,0.56999999999999995,0.1,0.1,1,1.18,10.54,12.36,22.9]
["S7","Apprentice 7",9.36,null,10,0.59,0.56999999999999995,0.1,0.1,1,1.27,10.629999999999999,12.36,22.99]
["S8","Apprentice 8",9.36,null,10,0.59,0.56999999999999995,0.1,0.1,1,1.36,10.719999999999999,12.36,23.08]
["S9","Apprentice 9",9.36,null,10,0.59,0.56999999999999995,0.1,0.1,1,1.45,10.809999999999999,12.36,23.169999999999998]
["S10","Apprentice 10",9.36,null,10,0.59,0.56999999999999995,0.1,0.1,1,1.63,10.989999999999998,12.36,23.349999999999998]
["S","Journeyman-Sprinklerfitter",9.36,null,10,0.59,0.56999999999999995,0.1,0.1,1,1.81,11.17,12.36,23.53]
["SF","Foreman-Sprinklerfitter",9.36,null,10,0.59,0.56999999999999995,0.1,0.1,1,1.94,11.299999999999999,12.36,23.659999999999997]
["SFA","Above Foreman-Sprinklerfitter",9.36,null,10,0.59,0.56999999999999995,0.1,0.1,1,2.02,11.379999999999999,12.36,23.74]
["SC","City Journeyman",9.36,null,10,0.59,null,0.1,0.1,1,1.94,11.299999999999999,11.79,23.089999999999996]
["SS","School Journeyman",9.36,null,10,0.59,0.56999999999999995,0.1,0.1,null,null,{"$f":"SUM(C20,K20)","v":9.36},{"$f":"SUM(E20:J20)","v":11.36},{"$f":"L20+M20","v":20.72}]
["ST","School Foreman",9.36,null,10,0.59,0.56999999999999995,0.1,0.1,null,null,9.36,11.36,20.72]

{"sheet":"TOTALS and CERTIFY","index":2,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3],[5,0,5,3],[7,11,11,11],[6,5,6,10],[8,5,8,10],[10,5,10,10],[1,0,1,3],[6,0,8,3]]}
["NOTICE!",null,null,null,"I certify this is a true and complete report of hours worked and that the contributions reflected "]
["Mail 1 copy with a check before the 15th of the month to:",null,null,null,"herein are made in conformity with the provisions dealing with contributions to the Funds in the "]
["PIPE TRADES SERVICES MN",null,null,null,"Collective Bargaining Agreement between the Union and Employers who executed the agreement and "]
["4461 WHITE BEAR PKWY, SUITE 1",null,null,null,"the Declaration of Trust establishing the Funds."]
["WHITE BEAR LAKE, MN 55110"]
["With check payable to: Pipe Trades Services MN"]
["This Fringe Benefit Report is DUE BY THE 15th of each month. Payments and reports RECEIVED AFTER THE 20th will be assessed liquidated damages at the following rates:",null,null,null,"Prepared By:"]
[]
[null,null,null,null,"Phone:"]
["1-10 days late = 3% of total fringes payable"]
["11 or more days late = 10% of total fringes payable",null,null,null,"Email:"]
[]
[]
["Total Dues","Total H&W","Total Pyramid Fringes","Total Supplement Pension","Total Apprenticeship","Total Industry Promotion","Total Building Fund","Total UA Training","Total Credit Union","Total Non Pyramid Fringes",null,"TOTAL FRINGE TO PTSMN"]
[{"$f":"'INPUT HOURS & CALC FRINGES'!J44","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!L44","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!M44","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!Q44","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!S44","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!U44","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!W44","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!Y44","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!AA44","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!AB44","v":0},null,{"$f":"'INPUT HOURS & CALC FRINGES'!AC44","v":0}]